/*
 Navicat MySQL Data Transfer

 Source Server         : study
 Source Server Type    : MySQL
 Source Server Version : 50729
 Source Host           : localhost:3306
 Source Schema         : WePrevent

 Target Server Type    : MySQL
 Target Server Version : 50729
 File Encoding         : 65001

 Date: 02/09/2020 21:41:23
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for User
-- ----------------------------
DROP TABLE IF EXISTS `User`;
CREATE TABLE `User` (
  `uid` int(10) NOT NULL AUTO_INCREMENT,
  `uname` varchar(30) DEFAULT NULL,
  `uphone` varchar(30) NOT NULL,
  `uemail` varchar(30) DEFAULT NULL,
  `upassword` varchar(30) DEFAULT NULL,
  PRIMARY KEY (`uid`),
  UNIQUE KEY `uphone` (`uphone`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of User
-- ----------------------------
BEGIN;
INSERT INTO `User` VALUES (2, '王志鹏', '18553657131', '2270368003@qq.com', '123');
INSERT INTO `User` VALUES (5, '张给', '18553657132', '2270368003@qq.com', '123');
COMMIT;

-- ----------------------------
-- Table structure for disaster
-- ----------------------------
DROP TABLE IF EXISTS `disaster`;
CREATE TABLE `disaster` (
  `did` int(10) NOT NULL AUTO_INCREMENT,
  `dtype` varchar(255) DEFAULT NULL,
  `ddegree` varchar(255) DEFAULT NULL,
  `dinfo` text,
  `dlocation` varchar(255) DEFAULT NULL,
  `dphone` varchar(255) DEFAULT NULL,
  `uid` int(10) DEFAULT NULL,
  `dtime` datetime DEFAULT NULL,
  PRIMARY KEY (`did`),
  KEY `uid` (`uid`),
  CONSTRAINT `uid` FOREIGN KEY (`uid`) REFERENCES `User` (`uid`)
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of disaster
-- ----------------------------
BEGIN;
INSERT INTO `disaster` VALUES (8, '人员伤亡', '轻微伤害', '人员伤亡，已紧急送医', '北京市东城区东长安街', '2322', 2, '2020-09-01 18:04:26');
INSERT INTO `disaster` VALUES (9, '人员伤亡', '人员死亡', '人员伤亡，已紧急送医', '北京市东城区东长安街14号', '23232', 2, '2020-09-01 18:04:22');
INSERT INTO `disaster` VALUES (10, '房屋破坏', '三间以上房屋倒塌', '', '北京市东城区东长安街中山公园派出所东60米', '12331', 2, '2020-09-01 18:04:19');
INSERT INTO `disaster` VALUES (11, '房屋破坏', '一间到三件房屋倒塌', '房屋破坏严重，无法生活', '北京市东城区东长安街14号', '23423', 2, '2020-09-01 18:04:29');
INSERT INTO `disaster` VALUES (12, '其他', '', '水管破裂', '贵州省贵阳市', '1233123', 2, '2020-09-01 18:04:16');
INSERT INTO `disaster` VALUES (13, '其他', '', '东南防线路面塌陷', '山东省日照市', '333', 2, '2020-09-01 11:10:38');
INSERT INTO `disaster` VALUES (14, '其他', '', '西北部出现蝗灾', '陕西省咸阳市', '123', 2, '2020-09-01 15:26:33');
INSERT INTO `disaster` VALUES (15, 'é®é®é¢', 'äº¬æ´¥å', 'qqq', 'qqq', '1111', 2, '2020-09-02 10:31:47');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
